USE [OctoNetApps]
GO

/****** Object:  StoredProcedure [classified].[ClassifiedResources_Update]    Script Date: 05/25/2011 07:02:50 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO




CREATE PROCEDURE [classified].[ClassifiedResources_Update]
	@ResourceID bigint,
	@Latitude float,
	@Longitude float,
	@AdminMail varchar(100)
AS
BEGIN

	SET NOCOUNT ON;
		
    UPDATE classified.ClassifiedResources
    SET 
		DefaultLocation = geography::Point(@Latitude, @Longitude, 4326),
		AdminMail = @AdminMail
	WHERE ResourceID = @ResourceID

END



GO


